<?php
InsertRecord('accountsection',array('sectionid'),array(10),array('sectionid','sectionname'),array(10,'Assets'), $db);
InsertRecord('accountsection',array('sectionid'),array(20),array('sectionid','sectionname'),array(20,'Liabilities'), $db);
InsertRecord('accountsection',array('sectionid'),array(30),array('sectionid','sectionname'),array(30,'Income'), $db);
InsertRecord('accountsection',array('sectionid'),array(40),array('sectionid','sectionname'),array(40,'Costs'), $db);
InsertRecord('accountgroups',array('groupname'),array('CAPITAL ASSETS'),array('groupname','sectioninaccounts','pandl','sequenceintb','parentgroupname'),array('CAPITAL ASSETS','10','0','3000',''), $db);
InsertRecord('accountgroups',array('groupname'),array('COST OF GOODS SOLD'),array('groupname','sectioninaccounts','pandl','sequenceintb','parentgroupname'),array('COST OF GOODS SOLD','40','1','10000',''), $db);
InsertRecord('accountgroups',array('groupname'),array('CURRENT ASSETS'),array('groupname','sectioninaccounts','pandl','sequenceintb','parentgroupname'),array('CURRENT ASSETS','10','0','1000',''), $db);
InsertRecord('accountgroups',array('groupname'),array('CURRENT LIABILITIES'),array('groupname','sectioninaccounts','pandl','sequenceintb','parentgroupname'),array('CURRENT LIABILITIES','20','0','4000',''), $db);
InsertRecord('accountgroups',array('groupname'),array('GENERAL & ADMINISTRATIVE EXPEN'),array('groupname','sectioninaccounts','pandl','sequenceintb','parentgroupname'),array('GENERAL & ADMINISTRATIVE EXPEN','40','1','12000',''), $db);
InsertRecord('accountgroups',array('groupname'),array('INVENTORY ASSETS'),array('groupname','sectioninaccounts','pandl','sequenceintb','parentgroupname'),array('INVENTORY ASSETS','10','0','2000',''), $db);
InsertRecord('accountgroups',array('groupname'),array('LONG TERM LIABILITIES'),array('groupname','sectioninaccounts','pandl','sequenceintb','parentgroupname'),array('LONG TERM LIABILITIES','20','0','5000',''), $db);
InsertRecord('accountgroups',array('groupname'),array('OTHER REVENUE'),array('groupname','sectioninaccounts','pandl','sequenceintb','parentgroupname'),array('OTHER REVENUE','30','1','9000',''), $db);
InsertRecord('accountgroups',array('groupname'),array('PAYROLL EXPENSES'),array('groupname','sectioninaccounts','pandl','sequenceintb','parentgroupname'),array('PAYROLL EXPENSES','40','1','11000',''), $db);
InsertRecord('accountgroups',array('groupname'),array('RETAINED EARNINGS'),array('groupname','sectioninaccounts','pandl','sequenceintb','parentgroupname'),array('RETAINED EARNINGS','20','0','7000',''), $db);
InsertRecord('accountgroups',array('groupname'),array('SALES REVENUE'),array('groupname','sectioninaccounts','pandl','sequenceintb','parentgroupname'),array('SALES REVENUE','30','1','8000',''), $db);
InsertRecord('accountgroups',array('groupname'),array('SHARE CAPITAL'),array('groupname','sectioninaccounts','pandl','sequenceintb','parentgroupname'),array('SHARE CAPITAL','20','0','6000',''), $db);
InsertRecord('chartmaster',array('accountcaode'),array('1060'),array('accountcode','accountname','group_'),array('1060','Checking Account','CURRENT ASSETS'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('1065'),array('accountcode','accountname','group_'),array('1065','Petty Cash','CURRENT ASSETS'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('1200'),array('accountcode','accountname','group_'),array('1200','Accounts Receivables','CURRENT ASSETS'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('1205'),array('accountcode','accountname','group_'),array('1205','Allowance for doubtful accounts','CURRENT ASSETS'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('1510'),array('accountcode','accountname','group_'),array('1510','Inventory','INVENTORY ASSETS'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('1820'),array('accountcode','accountname','group_'),array('1820','Office Furniture & Equipment','CAPITAL ASSETS'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('1825'),array('accountcode','accountname','group_'),array('1825','Accum. Amort. -Furn. & Equip.','CAPITAL ASSETS'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('1840'),array('accountcode','accountname','group_'),array('1840','Vehicle','CAPITAL ASSETS'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('1845'),array('accountcode','accountname','group_'),array('1845','Accum. Amort. -Vehicle','CAPITAL ASSETS'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2100'),array('accountcode','accountname','group_'),array('2100','Accounts Payable','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2110'),array('accountcode','accountname','group_'),array('2110','Accrued Income Tax - Federal','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2120'),array('accountcode','accountname','group_'),array('2120','Accrued Income Tax - State','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2130'),array('accountcode','accountname','group_'),array('2130','Accrued Franchise Tax','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2140'),array('accountcode','accountname','group_'),array('2140','Accrued Real & Personal Prop Tax','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2150'),array('accountcode','accountname','group_'),array('2150','Sales Tax','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2160'),array('accountcode','accountname','group_'),array('2160','Accrued Use Tax Payable','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2210'),array('accountcode','accountname','group_'),array('2210','Accrued Wages','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2220'),array('accountcode','accountname','group_'),array('2220','Accrued Comp Time','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2230'),array('accountcode','accountname','group_'),array('2230','Accrued Holiday Pay','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2240'),array('accountcode','accountname','group_'),array('2240','Accrued Vacation Pay','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2310'),array('accountcode','accountname','group_'),array('2310','Accr. Benefits - 401K','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2320'),array('accountcode','accountname','group_'),array('2320','Accr. Benefits - Stock Purchase','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2330'),array('accountcode','accountname','group_'),array('2330','Accr. Benefits - Med, Den','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2340'),array('accountcode','accountname','group_'),array('2340','Accr. Benefits - Payroll Taxes','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2350'),array('accountcode','accountname','group_'),array('2350','Accr. Benefits - Credit Union','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2360'),array('accountcode','accountname','group_'),array('2360','Accr. Benefits - Savings Bond','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2370'),array('accountcode','accountname','group_'),array('2370','Accr. Benefits - Garnish','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2380'),array('accountcode','accountname','group_'),array('2380','Accr. Benefits - Charity Cont.','CURRENT LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2620'),array('accountcode','accountname','group_'),array('2620','Bank Loans','LONG TERM LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('2680'),array('accountcode','accountname','group_'),array('2680','Loans from Shareholders','LONG TERM LIABILITIES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('3350'),array('accountcode','accountname','group_'),array('3350','Common Shares','SHARE CAPITAL'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('3590'),array('accountcode','accountname','group_'),array('3590','Retained Earnings - prior years','RETAINED EARNINGS'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('4010'),array('accountcode','accountname','group_'),array('4010','Sales','SALES REVENUE'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('4430'),array('accountcode','accountname','group_'),array('4430','Shipping & Handling','OTHER REVENUE'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('4440'),array('accountcode','accountname','group_'),array('4440','Interest','OTHER REVENUE'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('4450'),array('accountcode','accountname','group_'),array('4450','Foreign Exchange Gain','OTHER REVENUE'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5010'),array('accountcode','accountname','group_'),array('5010','Purchases','COST OF GOODS SOLD'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5100'),array('accountcode','accountname','group_'),array('5100','Freight','COST OF GOODS SOLD'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5410'),array('accountcode','accountname','group_'),array('5410','Wages & Salaries','PAYROLL EXPENSES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5420'),array('accountcode','accountname','group_'),array('5420','Wages - Overtime','PAYROLL EXPENSES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5430'),array('accountcode','accountname','group_'),array('5430','Benefits - Comp Time','PAYROLL EXPENSES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5440'),array('accountcode','accountname','group_'),array('5440','Benefits - Payroll Taxes','PAYROLL EXPENSES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5450'),array('accountcode','accountname','group_'),array('5450','Benefits - Workers Comp','PAYROLL EXPENSES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5460'),array('accountcode','accountname','group_'),array('5460','Benefits - Pension','PAYROLL EXPENSES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5470'),array('accountcode','accountname','group_'),array('5470','Benefits - General Benefits','PAYROLL EXPENSES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5510'),array('accountcode','accountname','group_'),array('5510','Inc Tax Exp - Federal','PAYROLL EXPENSES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5520'),array('accountcode','accountname','group_'),array('5520','Inc Tax Exp - State','PAYROLL EXPENSES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5530'),array('accountcode','accountname','group_'),array('5530','Taxes - Real Estate','PAYROLL EXPENSES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5540'),array('accountcode','accountname','group_'),array('5540','Taxes - Personal Property','PAYROLL EXPENSES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5550'),array('accountcode','accountname','group_'),array('5550','Taxes - Franchise','PAYROLL EXPENSES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5560'),array('accountcode','accountname','group_'),array('5560','Taxes - Foreign Withholding','PAYROLL EXPENSES'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5610'),array('accountcode','accountname','group_'),array('5610','Accounting & Legal','GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5615'),array('accountcode','accountname','group_'),array('5615','Advertising & Promotions','GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5620'),array('accountcode','accountname','group_'),array('5620','Bad Debts','GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5660'),array('accountcode','accountname','group_'),array('5660','Amortization Expense','GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5685'),array('accountcode','accountname','group_'),array('5685','Insurance','GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5690'),array('accountcode','accountname','group_'),array('5690','Interest & Bank Charges','GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5700'),array('accountcode','accountname','group_'),array('5700','Office Supplies','GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5760'),array('accountcode','accountname','group_'),array('5760','Rent','GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5765'),array('accountcode','accountname','group_'),array('5765','Repair & Maintenance','GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5780'),array('accountcode','accountname','group_'),array('5780','Telephone','GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5785'),array('accountcode','accountname','group_'),array('5785','Travel & Entertainment','GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5790'),array('accountcode','accountname','group_'),array('5790','Utilities','GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5795'),array('accountcode','accountname','group_'),array('5795','Registrations','GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5800'),array('accountcode','accountname','group_'),array('5800','Licenses','GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster',array('accountcaode'),array('5810'),array('accountcode','accountname','group_'),array('5810','Foreign Exchange Loss','GENERAL & ADMINISTRATIVE EXPEN'), $db);
?>